CimSQLTableConnection Json Schema

In This Topic

Description

Fields that describe the connection to a SQL connection

Overview

CimSQLTableConnection

Fields that describe the connection to a SQL connection

Table_id : string

Table id on which connection is updated.

SQLConnection : CimSQLConnection

Fields that describe the connection to a SQL connection

ConnectionType : CimSQLConnectionType

ODBCDataSource : string

ODBC Data connection.

UserID : string

User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.

Passsword : string

Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.

ReconnectWaitPeriod : integer

The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.

ReconnectWaitUnit : CimTimeUnitEnum

defines units for time values

EnableStoreAndForward : boolean

Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.

MaxNumberOfStoredRecord : number

To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.

Properties

Name	Description	Data Type
Table_id	Table id on which connection is updated.	string
SQLConnection	Fields that describe the connection to a SQL connection	CimSQLConnection
SQLConnection\ConnectionType		CimSQLConnectionType
SQLConnection\ODBCDataSource	ODBC Data connection.	string
SQLConnection\UserID	User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.	string
SQLConnection\Passsword	Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.	string
SQLConnection\ReconnectWaitPeriod	The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.	integer
SQLConnection\ReconnectWaitUnit	defines units for time values	CimTimeUnitEnum
SQLConnection\EnableStoreAndForward	Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.	boolean
SQLConnection\MaxNumberOfStoredRecord	To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.	number